Problem Note 41918: SAS® Add-In for Microsoft Office appears to stop responding when opening a Microsoft Excel file that contains data to be refreshed on open
 |  |  |  |  |
When using the SAS Add-In for Microsoft Office to open SAS tables, Microsoft Excel might appear to stop responding. This problem can occur when the Refresh on file open execution property is set for the SAS tables. You also might see an error similar to the following.
To circumvent the problem, deselect the Refresh on file open option on the Execution tab in the properties window of the SAS table.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A54.html#41918A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G36.html#41918A fix for this issue for SAS Enterprise Guide 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G35.html#41918| Type: | Problem Note |
| Priority: | medium |
| Topic: | Third Party ==> Products ==> Microsoft Office |
| Date Modified: | 2010-12-27 16:29:07 |
| Date Created: | 2010-12-20 12:53:04 |